Creating KPI's and the Slicer 11
Create Year Slicer and KPI's
-
Double click on the Slicer Icon
On the visualization bar.
-
Slicer visual will display
on the report.
- For the filed please select Year under Date Table
- Go to Format, click General, Y position = 0 width =211, height = 102
-
Click on the title and title text write Year
- Chose font color as White, and title color as dark brown # 6d5900
CCreate YoY KPI card.
1. Double click on the Card Icon on the visualization bar.
2. Card visual will display on the report
3. Drag and drop the YoY column from H-1B Visa Table
4. Click format, on Y position=0 Width=212, Height = 101
5. Click on Title, title box put YoY, change font color to white, background brown # 6d5900, center it, text size 14
Create Approved Cases KPI
1. Double click on the Card Icon on the visualization bar.
2. Card visual will display on the report
3. Drag and drop the Approved Cases column from H-1B Visa Table
4. Click format, on Y position=0 Width 212, Height = 102
5. Click on Title, title box put Approved Cases, change font color to white, background brown # 6d5900, center it, text size 14
Create Total Cases KPI
1. Double click on the Card Icon on the visualization bar.
2. Card visual will display on the report
3. Drag and drop the Total Cases column from H-1B Visa Table
4. Click format, on Y position=0 Width 212, Height = 102
5. Click on Title, title box put Approved Cases, change font color to white, background brown # 6d5900, center it, text size 14
6. Change format to Whole number
Below video is a tutorial on creating slicers:
https://www.youtube.com/watch?v=SA43PwWCilQ
Below Video is a tutorial on creating cards:
https://www.youtube.com/watch?v=DCaPmuXVHH0